Purchase Order Tables
Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.
tblPoForecastType -- PO Forecast Type table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ForecastType | nvarchar | 10 | |||
Descr | nvarchar | 35 | |||
AdjFactor | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblPoForecastTypeDetail -- PO Forecast Type Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ForecastType | nvarchar | 10 | |||
Period | smallint | 2 | 0 | ||
WeightFactor | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblPoHistDetail -- PO Detail History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
TransID | pTransID | 8 | |||
QtyOrd | pDecimal | 13 | |||
UnitCost | pDecimal | 13 | |||
UnitCostFgn | pDecimal | 13 | |||
ExtCost | pDecimal | 13 | |||
ExtCostFgn | pDecimal | 13 | |||
ItemId | pItemID | 24 | |||
ItemType | tinyint | 1 | Item Type | 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item | |
LocId | pLocID | 10 | |||
Descr | nvarchar | 35 | |||
UnitsBase | pUom | 5 | |||
Units | pUom | 5 | |||
LineStatus | tinyint | 1 | Line Status | 0 = Open, 1 = Completed | |
GLDesc | pGLDesc | 30 | |||
AddnlDescr | text | 16 | |||
TaxClass | tinyint | 1 | |||
BinNum | nvarchar | 10 | |||
ConversionFactor | pDecimal | 13 | |||
LottedYN | bit | 1 | |||
InItemYN | bit | 1 | |||
ReqShipDate | datetime | 8 | |||
GLAcct | pGlAcct | 40 | |||
GLAcctSales | pGlAcct | 40 | |||
GLAcctWIP | pGlAcct | 40 | |||
TransHistID | nvarchar | 10 | |||
CustID | pCustID | 10 | |||
ProjID | nvarchar | 10 | |||
ProjName | nvarchar | 30 | |||
PhaseId | nvarchar | 10 | |||
PhaseName | nvarchar | 30 | |||
TaskID | nvarchar | 10 | |||
TaskName | nvarchar | 30 | |||
UnitInc | pDecimal | 13 | |||
ExtInc | pDecimal | 13 | |||
ProjItemYn | bit | 1 | |||
QtySeqNum | int | 4 | |||
SourceType | smallint | 2 | |||
LineNum | int | 4 | |||
LinkTransId | pTransID | 8 | |||
Seq | int | 4 | |||
ReleaseNum | nvarchar | 3 | |||
ReqId | nvarchar | 4 | |||
LandedCostID | nvarchar | 10 | |||
LineSeq | int | 4 | |||
TransHistIDLandedCost | nvarchar | 10 | |||
LinkSeqNum | int | 4 | |||
CF | xml | -1 | |||
Type | tinyint | 1 | Type | 1 = Material, 2 = Expense, 3 = Other | |
ProjectDetailId | int | 4 | |||
ActivityId | int | 4 | |||
GLAcctAccrual | pGlAcct | 40 | |||
EntryNum | int | 4 | |||
ExpReceiptDate | datetime | 8 |
tblPoHistDetailLandedCost -- PO Landed Cost Detail History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
LCTransSeqNum | int | 4 | |||
TransID | pTransID | 8 | |||
EntryNum | int | 4 | |||
Description | nvarchar | 35 | |||
CostType | tinyint | 1 | Cost Type | 0 = Percent of Cost, 1 = Fixed Amount, 2 = Weight, 3 = Quantity | |
Amount | pDecimal | 13 | |||
Level | tinyint | 1 | |||
CalcAmount | pDecimal | 13 | |||
LCDtlSeqNum | int | 4 | |||
CF | xml | -1 |
tblPoHistHeader -- PO Header History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
TransId | pTransID | 8 | |||
BatchId | pBatchID | 6 | |||
TransType | smallint | 2 | Transaction Type | 1 = Goods Received, 2 = Invoice Received, 9 = New Order, -1 = New Return, -2 = Debit Memo | |
LocId | pLocID | 10 | |||
VendorId | pVendorID | 10 | |||
Notes | text | 16 | |||
DistCode | pDistCode | 6 | |||
TermsCode | pTermsCode | 6 | |||
TransDate | datetime | 8 | |||
TaxGrpID | pTaxLoc | 10 | |||
TaxableYn | bit | 1 | |||
PrintStatus | tinyint | 1 | Purchase Order Print Status | 0 = Unprinted, 1 = Online, 2 = Batch | |
PrintDate | datetime | 8 | |||
ReqShipDate | datetime | 8 | |||
OrderedBy | pUserID | 20 | |||
ReceivedBy | pUserID | 20 | |||
FOB | nvarchar | 35 | |||
CurrencyID | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | |||
ShipToID | pCustID | 10 | |||
ShipToAttn | nvarchar | 30 | |||
ShipToName | nvarchar | 30 | |||
ShipToAddr1 | nvarchar | 30 | |||
ShipToAddr2 | nvarchar | 60 | |||
ShipToCity | nvarchar | 30 | |||
ShipToRegion | nvarchar | 10 | |||
ShipToCountry | pCountry | 6 | |||
ShipToPostalCode | nvarchar | 10 | |||
ShipVia | nvarchar | 20 | |||
MemoTaxable | pDecimal | 13 | |||
MemoNonTaxable | pDecimal | 13 | |||
MemoSalesTax | pDecimal | 13 | |||
MemoFreight | pDecimal | 13 | |||
MemoMisc | pDecimal | 13 | |||
MemoDisc | pDecimal | 13 | |||
MemoPrepaid | pDecimal | 13 | |||
CheckDate | datetime | 8 | |||
MemoTaxableFgn | pDecimal | 13 | |||
MemoNonTaxableFgn | pDecimal | 13 | |||
MemoSalesTaxFgn | pDecimal | 13 | |||
MemoFreightFgn | pDecimal | 13 | |||
MemoMiscFgn | pDecimal | 13 | |||
MemoDiscFgn | pDecimal | 13 | |||
MemoPrepaidFgn | pDecimal | 13 | |||
MemoCheckNo | pCheckNum | 10 | |||
MemoDueDate1 | datetime | 8 | |||
MemoDueDate2 | datetime | 8 | |||
MemoDueDate3 | datetime | 8 | |||
MemoPmtAmt1 | pDecimal | 13 | |||
MemoPmtAmt2 | pDecimal | 13 | |||
MemoPmtAmt3 | pDecimal | 13 | |||
MemoPmtAmt1Fgn | pDecimal | 13 | |||
MemoPmtAmt2Fgn | pDecimal | 13 | |||
MemoPmtAmt3Fgn | pDecimal | 13 | |||
MemoTaxClassFreight | tinyint | 1 | |||
MemoTaxClassMisc | tinyint | 1 | |||
MemoTaxLocID1 | pTaxLoc | 10 | |||
MemoTaxAmt1 | pDecimal | 13 | |||
MemoTaxAmt1Fgn | pDecimal | 13 | |||
MemoTaxLocID2 | pTaxLoc | 10 | |||
MemoTaxAmt2 | pDecimal | 13 | |||
MemoTaxAmt2Fgn | pDecimal | 13 | |||
MemoTaxLocID3 | pTaxLoc | 10 | |||
MemoTaxAmt3 | pDecimal | 13 | |||
MemoTaxAmt3Fgn | pDecimal | 13 | |||
MemoTaxLocID4 | pTaxLoc | 10 | |||
MemoTaxAmt4 | pDecimal | 13 | |||
MemoTaxAmt4Fgn | pDecimal | 13 | |||
MemoTaxLocID5 | pTaxLoc | 10 | |||
MemoTaxAmt5 | pDecimal | 13 | |||
MemoTaxAmt5Fgn | pDecimal | 13 | |||
HdrRef | int | 4 | |||
DropShipYn | bit | 1 | 0 | ||
CF | xml | -1 | |||
GroupId | pTransID | 8 | |||
RequestedDate | datetime | 8 | |||
RequestedBy | pUserID | 20 | |||
ApprovedDate | datetime | 8 | |||
ApprovedBy | pUserID | 20 | |||
RequestStatus | tinyint | 1 | 0 = Approved, 1 = Declined | ||
ExpReceiptDate | datetime | 8 | |||
*TaxGrpId2 | pTaxLoc |
tblPoHistInvc_Rcpt -- PO Invoice Receipt History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
ReceiptID | uniqueidentifier | 16 | newid() | ||
InvoiceID | uniqueidentifier | 16 | newid() | ||
Qty | pDecimal | 13 | |||
QtySeqNum | int | 4 | |||
HistSeqNum | int | 4 | |||
CF | xml | -1 |
tblPoHistInvoice -- PO Invoice History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
EntryNum | int | 4 | |||
PostRun | pPostRun | 14 | |||
TransID | pTransID | 8 | |||
InvoiceNum | pInvoiceNum | 15 | |||
Status | tinyint | 1 | Status | 0 = Current, 1 = Posted | |
Qty | pDecimal | 13 | |||
UnitCost | pDecimal | 13 | |||
UnitCostFgn | pDecimal | 13 | |||
ExtCost | pDecimal | 13 | |||
ExtCostFgn | pDecimal | 13 | |||
HistSeqNum | int | 4 | |||
AvgRcptCost | pDecimal | 13 | |||
TransHistID | nvarchar | 10 | |||
QtySeqNum | int | 4 | |||
InvoiceID | uniqueidentifier | 16 | newid() | ||
CF | xml | -1 |
tblPoHistInvoiceTax -- PO Invoice Tax History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
TransId | pTransID | 8 | |||
InvcNum | pInvoiceNum | 15 | |||
TaxLocID | pTaxLoc | 10 | |||
TaxClass | tinyint | 1 | |||
ExpAcct | pGlAcct | 40 | |||
CurrTaxAmt | pDecimal | 13 | |||
CurrRefundable | pDecimal | 13 | |||
CurrTaxable | pDecimal | 13 | |||
CurrNonTaxable | pDecimal | 13 | |||
RefundAcct | pGlAcct | 40 | |||
CurrTaxAmtFgn | pDecimal | 13 | |||
CurrRefundableFgn | pDecimal | 13 | |||
CurrTaxableFgn | pDecimal | 13 | |||
CurrNonTaxableFgn | pDecimal | 13 | |||
CF | xml | -1 | |||
TaxGroupType | tinyint | 1 | 0 | 0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2 | |
LiabilityAccount | pGlAcct |
tblPoHistInvoiceTot -- PO Invoice Total History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
TransId | pTransID | 8 | |||
InvcNum | pInvoiceNum | 15 | |||
Status | tinyint | 1 | Invoice Status | 0 = Current, 1 = Posted | |
InvcDate | datetime | 8 | |||
GLPeriod | smallint | 2 | |||
FiscalYear | smallint | 2 | |||
Ten99InvoiceYN | bit | 1 | |||
CurrTaxable | pDecimal | 13 | |||
CurrNonTaxable | pDecimal | 13 | |||
CurrSalesTax | pDecimal | 13 | |||
CurrFreight | pDecimal | 13 | |||
CurrMisc | pDecimal | 13 | |||
CurrDisc | pDecimal | 13 | |||
CurrPrepaid | pDecimal | 13 | |||
CurrTaxableFgn | pDecimal | 13 | |||
CurrNonTaxableFgn | pDecimal | 13 | |||
CurrSalesTaxFgn | pDecimal | 13 | |||
CurrFreightFgn | pDecimal | 13 | |||
CurrMiscFgn | pDecimal | 13 | |||
CurrDiscFgn | pDecimal | 13 | |||
CurrPrepaidFgn | pDecimal | 13 | |||
PostTaxable | pDecimal | 13 | |||
PostNonTaxable | pDecimal | 13 | |||
PostSalesTax | pDecimal | 13 | |||
PostFreight | pDecimal | 13 | |||
PostMisc | pDecimal | 13 | |||
PostDisc | pDecimal | 13 | |||
PostPrepaid | pDecimal | 13 | |||
PostTaxableFgn | pDecimal | 13 | |||
PostNonTaxableFgn | pDecimal | 13 | |||
PostSalesTaxFgn | pDecimal | 13 | |||
PostFreightFgn | pDecimal | 13 | |||
PostMiscFgn | pDecimal | 13 | |||
PostDiscFgn | pDecimal | 13 | |||
PostPrepaidFgn | pDecimal | 13 | |||
CurrCheckNo | pCheckNum | 10 | |||
CurrCheckDate | datetime | 8 | |||
CurrBankID | pBankID | 10 | |||
CurrChkGlPeriod | smallint | 2 | |||
CurrChkFiscalYear | smallint | 2 | |||
CurrDueDate1 | datetime | 8 | |||
CurrDueDate2 | datetime | 8 | |||
CurrDueDate3 | datetime | 8 | |||
CurrPmtAmt1 | pDecimal | 13 | |||
CurrPmtAmt2 | pDecimal | 13 | |||
CurrPmtAmt3 | pDecimal | 13 | |||
CurrPmtAmt1Fgn | pDecimal | 13 | |||
CurrPmtAmt2Fgn | pDecimal | 13 | |||
CurrPmtAmt3Fgn | pDecimal | 13 | |||
CurrTaxClassFreight | tinyint | 1 | |||
CurrTaxClassMisc | tinyint | 1 | |||
CurrTaxAdjClass | tinyint | 1 | |||
CurrTaxAdjLocID | pTaxLoc | 10 | |||
CurrTaxAdjAmt | pDecimal | 13 | |||
CurrTaxAdjAmtFgn | pDecimal | 13 | |||
InvoiceExchRate | pDecimal | 13 | |||
PmtCurrencyId | pCurrency | 6 | |||
PmtExchRate | pDecimal | 13 | |||
-*GainLoss | pDecimal | 13 | |||
DiscDueDate | datetime | 8 | |||
CF | xml | -1 |
tblPoHistLotRcpt -- PO Lot Receipt History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
TransId | pTransID | 8 | |||
RcptNum | pInvoiceNum | 15 | |||
LotNum | pLotNum | 16 | |||
QtyOrder | pDecimal | 13 | |||
QtyFilled | pDecimal | 13 | |||
UnitCost | pDecimal | 13 | |||
UnitCostFgn | pDecimal | 13 | |||
ExtCost | pDecimal | 13 | |||
ExtCostFgn | pDecimal | 13 | |||
HistSeqNum | int | 4 | |||
LotCmnt | nvarchar | 35 | |||
Status | tinyint | 1 | Receipt Status | 0 = Current, 1 = Posted | |
QtySeqNum | int | 4 | |||
CF | xml | -1 | |||
AccAdjCost | pDecimal | 13 | |||
AccAdjCostFgn | pDecimal | 13 | |||
ActivityId | int | 4 | |||
EntryNum | int | 4 | |||
ExtLocAID | varchar | 10 | |||
ExtLocBID | varchar | 10 | |||
QtyAccRev | pDecimal | 13 | |||
QtySeqNum_Ext | int | 4 | |||
ReceiptID | uniqueidentifier | 16 | newid() |
tblPoHistReceipt -- PO Receipt History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
TransID | pTransID | 8 | |||
ReceiptNum | pInvoiceNum | 15 | |||
ReceiptDate | datetime | 8 | |||
GlPeriod | smallint | 2 | |||
FiscalYear | smallint | 2 | |||
ExchRate | pDecimal | 13 | -1 | ||
CF | xml | -1 |
tblPoHistReceiptLandedCost -- PO Landed Cost Receipt History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
ReceiptID | uniqueidentifier | 16 | newid() | ||
LCTransSeqNum | int | 4 | |||
Amount | pDecimal | 13 | |||
PostedAmount | pDecimal | 13 | |||
CF | xml | -1 |
tblPoHistSer -- PO Serial Number History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | |||
TransId | pTransID | 8 | |||
EntryNum | int | 4 | |||
RcptNum | pInvoiceNum | 15 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
InvcNum | pInvoiceNum | 15 | |||
SerCmnt | nvarchar | 35 | |||
RcptUnitCost | pDecimal | 13 | |||
*RcptCostUnitACV | pDecimal | 13 | |||
RcptUnitCostFgn | pDecimal | 13 | |||
RcptStatus | tinyint | 1 | Receipt Status | 0 = Current, 1 = Posted | |
InvcUnitCost | pDecimal | 13 | |||
*InvcCostUnitACV | pDecimal | 13 | |||
InvcUnitCostFgn | pDecimal | 13 | |||
InvcStatus | tinyint | 1 | Invoice Status | 0 = Current, 1 = Posted | |
SerHistSeqNum | int | 4 | |||
ExchRateSRec | pDecimal | 13 | |||
ExchRateSInv | pDecimal | 13 | |||
CF | xml | -1 | |||
ExtLocAID | nvarchar | 10 | |||
ExtLocBID | nvarchar | 10 |
tblPoItemLocReorder -- PO Item Reorder Location table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
UomDflt | pUom | 5 | |||
QtyOnHand | pDecimal | 13 | 0 | ||
QtyOnOrder | pDecimal | 13 | 0 | ||
SafetyStock | pDecimal | 13 | 0 | ||
UsageForecast | pDecimal | 13 | 0 | ||
UsageAnnual | pDecimal | 13 | 0 | ||
OrderPointEoq | pDecimal | 13 | 0 | ||
OrderPointFrcst | pDecimal | 13 | 0 | ||
OrderPointMinMax | pDecimal | 13 | 0 | ||
OrderQtyEoq | pDecimal | 13 | 0 | ||
OrderQtyFrcst | pDecimal | 13 | 0 | ||
OrderQtyMinMax | pDecimal | 13 | 0 | ||
NotesEoq | nvarchar | 2 | |||
NotesFrcst | nvarchar | 2 | |||
NotesMinMax | nvarchar | 2 | |||
FrozenEoq | bit | 1 | 0 | ||
FrozenFrcst | bit | 1 | 0 | ||
FrozenQtyYN | bit | 1 | 0 | ||
AutoReorderYN | bit | 1 | 0 | ||
GlInvAcct | pGlAcct | 40 | |||
AboveEoqOrdPt | bit | 1 | 0 | ||
AboveFrcstOrdPt | bit | 1 | 0 | ||
AboveMinMaxOrdPt | bit | 1 | 0 | ||
AboveAllOrdPt | bit | 1 | 0 | ||
MinOrderQty | pDecimal | 13 | 0 | ||
MaxOrderQty | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblPoLandedCostDetail -- PO Landed Cost Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
LandedCostID | nvarchar | 10 | |||
LCDtlSeqNum | int | 4 | |||
Description | nvarchar | 35 | |||
CostType | tinyint | 1 | Cost Type | 0 = Percent of Cost, 1 = Fixed Amount, 2 = Weight, 3 = Quantity | |
Amount | pDecimal | 13 | 0 | ||
Level | tinyint | 1 | |||
GlAcctExpense | pGlAcct | 40 | |||
CF | xml | -1 |
tblPoLandedCostHeader -- PO Landed Cost Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
LandedCostID | nvarchar | 10 | |||
Description | nvarchar | 35 | |||
CF | xml | -1 |
tblPoPurchaseReq -- PO Purchase Requisition table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ReqId | int | 4 | |||
VendorId | pVendorID | 10 | |||
ItemId | pItemID | 24 | |||
ItemType | tinyint | 1 | 0 | Item Type | 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item |
LocId | pLocID | 10 | |||
Descr | nvarchar | 35 | |||
Qty | pDecimal | 13 | 0 | ||
UnitCost | pDecimal | 13 | 0 | ||
ExtCost | pDecimal | 13 | 0 | ||
Uom | pUom | 5 | |||
InitDate | datetime | 8 | |||
EnteredBy | pUserID | 20 | |||
SourceApp | nvarchar | 2 | |||
RefId | nvarchar | 15 | |||
GenerateYn | bit | 1 | 0 | ||
GlAcct | pGlAcct | 40 | |||
ReqShipDate | datetime | 8 | |||
AddnlDescr | text | 16 | |||
DropShipYn | bit | 1 | 0 | ||
SourceType | smallint | 2 | Source Type | 0 = NA, 1 = PO Requisition, 2 = PO Transaction, 70 = JC, 71 = SO, 72 = SD, 73 = MP Material, 74 = MP Subcontract | |
LineNum | int | 4 | |||
LinkTransId | pTransID | 8 | |||
Seq | int | 4 | |||
ReleaseNum | nvarchar | 3 | |||
OrderReqId | nvarchar | 4 | |||
LinkSeqNum | int | 4 | |||
CustId | pCustID | 10 | |||
ProjId | nvarchar | 10 | |||
PhaseId | nvarchar | 10 | |||
TaskId | nvarchar | 10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*CurrencyID | pCurrency | 6 | |||
ExpReceiptDate | datetime | 8 |
tblPoShipTo -- PO Ship To table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ShiptoId | pCustID | 10 | |||
ShiptoName | nvarchar | 30 | |||
Addr1 | nvarchar | 30 | |||
Addr2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | nvarchar | 10 | |||
IntlPrefix | nvarchar | 6 | |||
Phone | nvarchar | 15 | |||
Fax | nvarchar | 15 | |||
Attn | nvarchar | 30 | |||
ShipVia | nvarchar | 20 | |||
TaxLocID | pTaxLoc | 10 | |||
DistCode | pDistCode | 6 | |||
pEmail | 255 | ||||
Internet | pWeb | 255 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblPoTransDetail -- PO Transaction Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransID | pTransID | 8 | |||
EntryNum | int | 4 | |||
QtyOrd | pDecimal | 13 | 0 | ||
UnitCost | pDecimal | 13 | 0 | ||
UnitCostFgn | pDecimal | 13 | 0 | ||
ExtCost | pDecimal | 13 | 0 | ||
ExtCostFgn | pDecimal | 13 | 0 | ||
ItemId | pItemID | 24 | |||
ItemType | tinyint | 1 | 0 | Item Type | 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item |
LocId | pLocID | 10 | |||
Descr | nvarchar | 35 | |||
UnitsBase | pUom | 5 | |||
Units | pUom | 5 | |||
LineStatus | tinyint | 1 | 0 | Line Status | 0 = Open, 1 = Completed |
GLDesc | pGLDesc | 30 | |||
AddnlDescr | text | 16 | |||
TaxClass | tinyint | 1 | 0 | ||
BinNum | nvarchar | 10 | |||
ConversionFactor | pDecimal | 13 | -1 | ||
LottedYN | bit | 1 | 0 | ||
InItemYN | bit | 1 | -1 | ||
ReqShipDate | datetime | 8 | getdate() | ||
GLAcct | pGlAcct | 40 | |||
GLAcctSales | pGlAcct | 40 | |||
GLAcctWIP | pGlAcct | 40 | |||
TransHistID | nvarchar | 10 | |||
CustID | pCustID | 10 | |||
ProjID | nvarchar | 10 | |||
ProjName | nvarchar | 30 | |||
PhaseId | nvarchar | 10 | |||
PhaseName | nvarchar | 30 | |||
TaskID | nvarchar | 10 | |||
TaskName | nvarchar | 30 | |||
UnitInc | pDecimal | 13 | 0 | ||
ExtInc | pDecimal | 13 | 0 | ||
ProjItemYn | bit | 1 | 0 | ||
QtySeqNum | int | 4 | 0 | ||
SourceType | smallint | 2 | Source Type | 0 = NA, 1 = PO Requisition, 2 = PO Transaction, 70 = JC, 71 = SO, 72 = SD, 73 = MP Material, 74 = MP Subcontract | |
LineNum | int | 4 | |||
LinkTransId | pTransID | 8 | |||
Seq | int | 4 | |||
ReleaseNum | nvarchar | 3 | |||
ReqId | nvarchar | 4 | |||
LinkSeqNum | int | 4 | |||
LandedCostID | nvarchar | 10 | |||
LineSeq | int | 4 | |||
TransHistIDLandedCost | nvarchar | 10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
Type | tinyint | 1 | Type | 1 = Material, 2 = Expense, 3 = Other | |
ProjectDetailId | int | 4 | |||
ActivityId | int | 4 | |||
GLAcctAccrual | pGlAcct | 40 | |||
EntryNum | int | 4 | |||
*QtySeqNum_Ext | int | 4 | 0 | ||
*ExtLocA | int |
tblPoTransDetailLandedCost -- PO Landed Cost Transaction Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
LCTransSeqNum | int | 4 | |||
TransID | pTransID | 8 | |||
EntryNum | int | 4 | |||
Description | nvarchar | 35 | |||
CostType | tinyint | 1 | Cost Type | 0 = Percent of Cost, 1 = Fixed Amount, 2 = Weight, 3 = Quantity | |
Amount | pDecimal | 13 | 0 | ||
Level | tinyint | 1 | |||
CalcAmount | pDecimal | 13 | 0 | ||
LCDtlSeqNum | int | 4 | |||
CF | xml | -1 | |||
ExpReceiptDate | datetime | 8 |
tblPoTransHeader -- PO Transaction Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | z | ||
BatchId | pBatchID | 6 | '######' | ||
TransType | smallint | 2 | 9 | Transaction Type | 0 = Request,1 = Goods Received, 2 = Invoice Received, 9 = New Order, -1 = New Return, -2 = Debit Memo |
LocId | pLocID | 10 | |||
VendorId | pVendorID | 10 | |||
Notes | text | 16 | |||
DistCode | pDistCode | 6 | |||
TermsCode | pTermsCode | 6 | |||
TransDate | datetime | 8 | getdate() | ||
TaxGrpID | pTaxLoc | 10 | |||
TaxableYn | bit | 1 | -1 | ||
PrintStatus | tinyint | 1 | 0 | Purchase Order Print Status | 0 = Unprinted, 1 = Online, 2 = Batch |
PrintDate | datetime | 8 | |||
ReqShipDate | datetime | 8 | getdate() | ||
OrderedBy | pUserID | 20 | |||
ReceivedBy | pUserID | 20 | |||
FOB | nvarchar | 35 | |||
CurrencyID | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | -1 | ||
ShipToID | pCustID | 10 | |||
ShipToAttn | nvarchar | 30 | |||
ShipToName | nvarchar | 30 | |||
ShipToAddr1 | nvarchar | 30 | |||
ShipToAddr2 | nvarchar | 60 | |||
ShipToCity | nvarchar | 30 | |||
ShipToRegion | nvarchar | 10 | |||
ShipToCountry | pCountry | 6 | |||
ShipToPostalCode | nvarchar | 10 | |||
ShipVia | nvarchar | 20 | |||
MemoTaxable | pDecimal | 13 | 0 | ||
MemoNonTaxable | pDecimal | 13 | 0 | ||
MemoSalesTax | pDecimal | 13 | 0 | ||
MemoFreight | pDecimal | 13 | 0 | ||
MemoMisc | pDecimal | 13 | 0 | ||
MemoDisc | pDecimal | 13 | 0 | ||
MemoPrepaid | pDecimal | 13 | 0 | ||
CheckDate | datetime | 8 | |||
MemoTaxableFgn | pDecimal | 13 | 0 | ||
MemoNonTaxableFgn | pDecimal | 13 | 0 | ||
MemoSalesTaxFgn | pDecimal | 13 | 0 | ||
MemoFreightFgn | pDecimal | 13 | 0 | ||
MemoMiscFgn | pDecimal | 13 | 0 | ||
MemoDiscFgn | pDecimal | 13 | 0 | ||
MemoPrepaidFgn | pDecimal | 13 | 0 | ||
MemoCheckNo | pCheckNum | 10 | |||
MemoDueDate1 | datetime | 8 | |||
MemoDueDate2 | datetime | 8 | |||
MemoDueDate3 | datetime | 8 | |||
MemoPmtAmt1 | pDecimal | 13 | 0 | ||
MemoPmtAmt2 | pDecimal | 13 | 0 | ||
MemoPmtAmt3 | pDecimal | 13 | 0 | ||
MemoPmtAmt1Fgn | pDecimal | 13 | 0 | ||
MemoPmtAmt2Fgn | pDecimal | 13 | 0 | ||
MemoPmtAmt3Fgn | pDecimal | 13 | 0 | ||
MemoTaxClassFreight | tinyint | 1 | 0 | ||
MemoTaxClassMisc | tinyint | 1 | 0 | ||
MemoTaxLocID1 | pTaxLoc | 10 | |||
MemoTaxAmt1 | pDecimal | 13 | 0 | ||
MemoTaxAmt1Fgn | pDecimal | 13 | 0 | ||
MemoTaxLocID2 | pTaxLoc | 10 | |||
MemoTaxAmt2 | pDecimal | 13 | 0 | ||
MemoTaxAmt2Fgn | pDecimal | 13 | 0 | ||
MemoTaxLocID3 | pTaxLoc | 10 | |||
MemoTaxAmt3 | pDecimal | 13 | 0 | ||
MemoTaxAmt3Fgn | pDecimal | 13 | 0 | ||
MemoTaxLocID4 | pTaxLoc | 10 | |||
MemoTaxAmt4 | pDecimal | 13 | 0 | ||
MemoTaxAmt4Fgn | pDecimal | 13 | 0 | ||
MemoTaxLocID5 | pTaxLoc | 10 | |||
MemoTaxAmt5 | pDecimal | 13 | 0 | ||
MemoTaxAmt5Fgn | pDecimal | 13 | 0 | ||
DropShipYn | bit | 1 | 0 | ||
HdrRef | int | 4 | |||
CF | xml | -1 | |||
*TaxGrpId2 | pTaxLoc |
tblPoTransInvc_Rcpt -- PO Transaction Invoice Receipt table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Qty | pDecimal | 13 | 0 | ||
QtySeqNum | int | 4 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
ReceiptID | uniqueidentifier | 16 | newid() | ||
InvoiceID | uniqueidentifier | 16 | newid() | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblPoTransInvoice -- PO Transaction Invoice table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransID | pTransID | 8 | |||
EntryNum | int | 4 | 0 | ||
InvoiceNum | pInvoiceNum | 15 | |||
Status | tinyint | 1 | 0 | Invoice Status | 0 = Current, 1 = Posted |
Qty | pDecimal | 13 | 0 | ||
UnitCost | pDecimal | 13 | 0 | ||
UnitCostFgn | pDecimal | 13 | 0 | ||
ExtCost | pDecimal | 13 | 0 | ||
ExtCostFgn | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
AvgRcptCost | pDecimal | 13 | 0 | ||
TransHistID | nvarchar | 10 | |||
QtySeqNum | int | 4 | 0 | ||
InvoiceID | uniqueidentifier | 16 | newid() | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*InvcHeaderID | bigint | 8 | |||
ExpReceiptDate | datetime | 8 |
tblPoTransInvoiceTax -- PO Transaction Invoice Tax table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
InvcNum | pInvoiceNum | 15 | |||
TaxLocID | pTaxLoc | 10 | |||
TaxClass | tinyint | 1 | 0 | ||
ExpAcct | pGlAcct | 40 | |||
CurrTaxAmt | pDecimal | 13 | 0 | ||
CurrRefundable | pDecimal | 13 | 0 | ||
CurrTaxable | pDecimal | 13 | 0 | ||
CurrNonTaxable | pDecimal | 13 | 0 | ||
RefundAcct | pGlAcct | 40 | |||
CurrTaxAmtFgn | pDecimal | 13 | 0 | ||
CurrRefundableFgn | pDecimal | 13 | 0 | ||
CurrTaxableFgn | pDecimal | 13 | 0 | ||
CurrNonTaxableFgn | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
TaxGroupType | tinyint | 1 | 0 | 0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2 | |
LiabilityAccount | pGlAcct |
tblPoTransInvoiceTot -- PO Transaction Invoice Total table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
*ID | bigint | 8 | |||
TransId | pTransID | 8 | |||
InvcNum | pInvoiceNum | 15 | |||
Status | tinyint | 1 | 0 | Invoice Status | 0 = Current, 1 = Posted |
InvcDate | datetime | 8 | getdate() | ||
GLPeriod | smallint | 2 | 0 | ||
FiscalYear | smallint | 2 | 0 | ||
Ten99InvoiceYN | bit | 1 | 0 | ||
CurrTaxable | pDecimal | 13 | 0 | ||
CurrNonTaxable | pDecimal | 13 | 0 | ||
CurrSalesTax | pDecimal | 13 | 0 | ||
CurrFreight | pDecimal | 13 | 0 | ||
CurrMisc | pDecimal | 13 | 0 | ||
CurrDisc | pDecimal | 13 | 0 | ||
CurrPrepaid | pDecimal | 13 | 0 | ||
CurrTaxableFgn | pDecimal | 13 | 0 | ||
CurrNonTaxableFgn | pDecimal | 13 | 0 | ||
CurrSalesTaxFgn | pDecimal | 13 | 0 | ||
CurrFreightFgn | pDecimal | 13 | 0 | ||
CurrMiscFgn | pDecimal | 13 | 0 | ||
CurrDiscFgn | pDecimal | 13 | 0 | ||
CurrPrepaidFgn | pDecimal | 13 | 0 | ||
PostTaxable | pDecimal | 13 | 0 | ||
PostNonTaxable | pDecimal | 13 | 0 | ||
PostSalesTax | pDecimal | 13 | 0 | ||
PostFreight | pDecimal | 13 | 0 | ||
PostMisc | pDecimal | 13 | 0 | ||
PostDisc | pDecimal | 13 | 0 | ||
PostPrepaid | pDecimal | 13 | 0 | ||
PostTaxableFgn | pDecimal | 13 | 0 | ||
PostNonTaxableFgn | pDecimal | 13 | 0 | ||
PostSalesTaxFgn | pDecimal | 13 | 0 | ||
PostFreightFgn | pDecimal | 13 | 0 | ||
PostMiscFgn | pDecimal | 13 | 0 | ||
PostDiscFgn | pDecimal | 13 | 0 | ||
PostPrepaidFgn | pDecimal | 13 | 0 | ||
CurrCheckNo | pCheckNum | 10 | |||
CurrCheckDate | datetime | 8 | |||
CurrBankID | pBankID | 10 | |||
CurrChkGlPeriod | smallint | 2 | |||
CurrChkFiscalYear | smallint | 2 | |||
CurrDueDate1 | datetime | 8 | |||
CurrDueDate2 | datetime | 8 | |||
CurrDueDate3 | datetime | 8 | |||
CurrPmtAmt1 | pDecimal | 13 | 0 | ||
CurrPmtAmt2 | pDecimal | 13 | 0 | ||
CurrPmtAmt3 | pDecimal | 13 | 0 | ||
CurrPmtAmt1Fgn | pDecimal | 13 | 0 | ||
CurrPmtAmt2Fgn | pDecimal | 13 | 0 | ||
CurrPmtAmt3Fgn | pDecimal | 13 | 0 | ||
CurrTaxClassFreight | tinyint | 1 | 0 | ||
CurrTaxClassMisc | tinyint | 1 | 0 | ||
CurrTaxAdjClass | tinyint | 1 | 0 | ||
CurrTaxAdjLocID | pTaxLoc | 10 | |||
CurrTaxAdjAmt | pDecimal | 13 | 0 | ||
CurrTaxAdjAmtFgn | pDecimal | 13 | 0 | ||
InvoiceExchRate | pDecimal | 13 | -1 | ||
PmtCurrencyId | pCurrency | 6 | |||
PmtExchRate | pDecimal | 13 | -1 | ||
-*GainLoss | pDecimal | 13 | 0 | ||
DiscDueDate | datetime | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblPoTransLotRcpt -- PO Transaction Lot Receipt table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ActivityId | int | 4 | |||
*ID | bigint | 8 | |||
*RcptHeaderId | bigint | 8 | |||
TransId | pTransID | 8 | |||
EntryNum | int | 4 | 0 | ||
RcptNum | pInvoiceNum | 15 | |||
LotNum | pLotNum | 16 | |||
QtyOrder | pDecimal | 13 | 0 | ||
QtyFilled | pDecimal | 13 | 0 | ||
UnitCost | pDecimal | 13 | 0 | ||
UnitCostFgn | pDecimal | 13 | 0 | ||
ExtCost | pDecimal | 13 | 0 | ||
ExtCostFgn | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
LotCmnt | nvarchar | 35 | |||
Status | tinyint | 1 | 0 | Receipt Status | 0 = Current, 1 = Posted |
QtySeqNum | int | 4 | 0 | ||
ReceiptID | uniqueidentifier | 16 | newid() | ||
QtyAccRev | pDecimal | 13 | 0 | ||
AccAdjCostFgn | pDecimal | 13 | 0 | ||
AccAdjCost | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
QtySeqNum_Ext | int | 4 | 0 |
tblPoTransReceipt -- PO Transaction Receipt table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransID | pTransID | 8 | |||
ReceiptNum | pInvoiceNum | 15 | |||
ReceiptDate | datetime | 8 | getdate() | ||
GlPeriod | smallint | 2 | 0 | ||
FiscalYear | smallint | 2 | 0 | ||
ExchRate | pDecimal | 13 | -1 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblPoTransReceiptLandedCost -- PO Transaction Receipt Landed Cost table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ReceiptID | uniqueidentifier | 16 | newid() | ||
LCTransSeqNum | int | 4 | |||
Amount | pDecimal | 13 | 0 | ||
PostedAmount | pDecimal | 13 | 0 | ||
CF | xml | -1 |
tblPoTransRequest -- PO Transaction Request table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
GroupId | pTransID | 8 | |||
RequestedDate | datetime | 8 | |||
RequestedBy | pUserID | 8 | |||
ApprovedDate | datetime | 8 | |||
ApprovedBy | pUserID | 8 | |||
Status | tinyint | 1 | Status | 0 = New, 1 = Pending, 2 = Approved, 3 = Declined | |
ts | timestamp | 8 |
tblPoTransSer -- PO Serial Number Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
EntryNum | int | 4 | 0 | ||
RcptNum | pInvoiceNum | 15 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
InvcNum | pInvoiceNum | 15 | |||
SerCmnt | nvarchar | 35 | |||
RcptUnitCost | pDecimal | 13 | 0 | ||
RcptUnitCostFgn | pDecimal | 13 | 0 | ||
RcptStatus | tinyint | 1 | 0 | Receipt Status | 0 = Current, 1 = Posted |
InvcUnitCost | pDecimal | 13 | 0 | ||
InvcUnitCostFgn | pDecimal | 13 | 0 | ||
InvcStatus | tinyint | 1 | 0 | Invoice Status | 0 = Current, 1 = Posted |
SerHistSeqNum | int | 4 | 0 | ||
ExchRateSRec | pDecimal | 13 | -1 | ||
ExchRateSInv | pDecimal | 13 | -1 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | z | ||
ExtLocA | int | 4 | z | ||
ExtLocB | int | 4 | |||
*RcptCostUnitACV | pDecimal | 13 | |||
*InvcCostUnitACV | pDecimal | 13 |